GrapeCity.CalcEngine.Functions Namespace > CalcIndexFunction Class > Evaluate Method : Evaluate(Object[],Object) Method |
The args contains 2 - 4 items: array, row_num, [column_num], [Area_num].
Array is a range of cells or an array constant.
Row_num selects the row in array from which to return a value. If row_num is omitted, column_num is required.
[Column_num] selects the column in array from which to return a value. If column_num is omitted, row_num is required.
[Area_num] selects a range in reference from which to return the intersection of row_num and column_num.'Declaration Public Overloads Overrides Function Evaluate( _ ByVal args() As Object, _ ByVal context As Object _ ) As Object
'Usage Dim instance As CalcIndexFunction Dim args() As Object Dim context As Object Dim value As Object value = instance.Evaluate(args, context)
The args contains 2 - 4 items: array, row_num, [column_num], [Area_num].
Array is a range of cells or an array constant.
Row_num selects the row in array from which to return a value. If row_num is omitted, column_num is required.
[Column_num] selects the column in array from which to return a value. If column_num is omitted, row_num is required.
[Area_num] selects a range in reference from which to return the intersection of row_num and column_num.Target Platforms: Windows Server 2012, Windows RT